Help With Look Up Functions

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hello,

I am working with a range of unsorted data which I would like to look
up the first instance of "ON" and return the value in the adjacent
column.

Status Fuel Flow
OFF 13,116
OFF 13,129
OFF 13,142
ON 13,154
ON 13,167
ON 13,180
ON 13,192

For example in this example I would like to pick out the fuel flow
value on the first instance of ON, so it should return the value
13,154.

I am having a bit of trouble figuring this out and would appreciate
any assistance.

Thanks so much,
Mark
 
With your table named as MyRng

=VLOOKUP("ON",MyRng,2,0)

With the value ON in say cell A1:-

=VLOOKUP(A1,MyRng,2,0)
 
Thank you....

Ken Wright said:
With your table named as MyRng

=VLOOKUP("ON",MyRng,2,0)

With the value ON in say cell A1:-

=VLOOKUP(A1,MyRng,2,0)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission :-)
-------------------------------------------------------------------------- --
Click to expand...
 
Back
Top