VLOOKUP TEXT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

In Sheet 2, D10 needs to be the Price of Product mentioned in C

Sheet 1 Column B contains the Product (TEXT) & Column D contains the Pric

The Formula =VLOOKUP(C1,Sheet 1!B1:D300,3) does not give the desired value (infact it shows Price of Product in B114
Please hel

Regard
Sachin
 
Hi Sachin

i'm guessing you need to use the fourth parameter of VLOOKUP
False means do an exact match
when it is omitted or true is specified then an approximate match is done.

Modify your formula to:
=VLOOKUP(C1,Sheet 1!$B$1:$D$300,3,false)
and you might get a better result (i've included the $ so that you can fill
it down easily)

Cheers
JulieD

Sachin said:
Hi!

In Sheet 2, D10 needs to be the Price of Product mentioned in C1

Sheet 1 Column B contains the Product (TEXT) & Column D contains the Price

The Formula =VLOOKUP(C1,Sheet 1!B1:D300,3) does not give the desired value
Click to expand...
(infact it shows Price of Product in B114)
 
Hi
try
=VLOOKUP(C1,Sheet 1!$B$1:$D$300,3,0)

--
Regards
Frank Kabel
Frankfurt, Germany

Sachin said:
Hi!

In Sheet 2, D10 needs to be the Price of Product mentioned in C1

Sheet 1 Column B contains the Product (TEXT) & Column D contains the Price

The Formula =VLOOKUP(C1,Sheet 1!B1:D300,3) does not give the desired
Click to expand...
value (infact it shows Price of Product in B114)
 
Unless your products in Sheet1, column B are sorted ascending, you need
to use the range_lookup argument:

Try:

=VLOOKUP(C1, Sheet1!B1:D300, 3, FALSE)
 
Back
Top