VLOOKUP to determine...

  • Thread starter Thread starter Gerry
  • Start date Start date
G

Gerry

Is there a basic formula I could place in cell A1 in
Sheet1 that returns the value from Sheet2 but specifically
from the ROW I call for in a cell in Sheet2 G1 ?

An example is: in Sheet1 A1 I would like the value from
Sheet2 D100 when I enter 100 (the row number) in Sheet2 G1.

The lopgic escapes so far... thanks to those that have
contributed so far to a solution. I feel I'm close!

TIA,
Gerry
 
Thanks Jason, my original intent to merge the last entry
syntax with a change up in row specification such as this
solution allows, but... this very works well and I'll go
with it.
Many Thanks!
 
Back
Top