Vlookup

  • Thread starter Thread starter gadi13
  • Start date Start date
G

gadi13

Hello all excel genuises, I NEED HELP! Using Vlookup I nned to get
value to the right of the selected cell - Easy! List is text and canno
be in order. Or possibly a match solution.

I have it like this =vlookup(m1,e1:F48,1) remeber the text is not i
order what can I Do.


Tank
 
Hi Gadi13

Try:

=VLOOKUP(M1,$E$1:$F$48,2,0)

Looks up the value in M1 in a table in E1:F4. If an exact match is
found, it returns the value in column 2 of the table.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi
to things to do to achieve this:
- the 3rd parameter of VLOOKUP indicated which row to return from the
lookup_range
- the 4th parameter indicated if you're looking for an excact match or
not.
Try
=vlookup(m1,e1:F48,2,0)

Frank
 
Back
Top