VLOOKUP TEXT

[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!B1300,3) does not give the desired value (infact it shows Price of Product in B114
Please hel

Regard
Sachin

 

[JulieD]

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

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!B1300,3) does not give the desired value

(infact it shows Price of Product in B114)

 

[Frank Kabel]

Hi
try
=VLOOKUP(C1,Sheet 1!$B$1:$D$300,3,0)

--
Regards
Frank Kabel
Frankfurt, Germany

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!B1300,3) does not give the desired

value (infact it shows Price of Product in B114)

 

[JE McGimpsey]

Unless your products in Sheet1, column B are sorted ascending, you need
to use the range_lookup argument:

Try:

=VLOOKUP(C1, Sheet1!B1300, 3, FALSE)

 

[Guest]

=VLOOKUP(C1, Sheet1!B1300, 3, 0
=VLOOKUP(C1, Sheet1!B1300, 3, FALSE

WORKED! THANX