Vlookup wont work

[PaulHarte]

Hi all,

Can anybody please help....

I have an excel sheet with two sheets (sheet1 and sheet2).

Sheet 1 has the following cols: -

1 COL A_____COL B_______COL C__________COL D
2 Product___Serial______Concat_________Rack
3 abc_______123_________abc123___________1A
4 abc_______345_________abc345___________2
5 xyz_______901_________xyz901___________4

I am using the Concatenation of Col a & b to give me a unique id for each product.

Sheet two has a whole bunch of other cols (including the Concat col) i.e. size, power and so on...

what i want to do is insert a column (e) and pull the relevant info to sheet 1 for that product.

The forumula that i am using doesnt seen to work .. and i cannot figure out why...

=VLOOKUP(A3,Sheet2!A2:A100,4,FALSE)

NB: formula on sheet1

can anybody please help???

Best regards

Paul

[ This Message was edited by: PaulHarte on 2002-05-19 08:20 ]

[ This Message was edited by: PaulHarte on 2002-05-19 08:21 ]

[ This Message was edited by: PaulHarte on 2002-05-19 08:22 ]

[ This Message was edited by: PaulHarte on 2002-05-19 08:24 ]

[Aladin Akyurek]

Sheet 1 has the following cols: -

1 COL A_____COL B_______COL C__________COL D
2 Product___Serial______Concat_________Rack
3 abc_______123_________abc123___________1A
4 abc_______345_________abc345___________2
5 xyz_______901_________xyz901___________4

I am using the Concatenation of Col a & b to give me a unique id for each product.

Sheet two has a whole bunch of other cols (including the Concat col) i.e. size, power and so on...

what i want to do is insert a column (e) and pull the relevant info to sheet 1 for that product.

The forumula that i am using doesnt seen to work .. and i cannot figure out why...

=VLOOKUP(A3,Sheet2!A2:A100,4,FALSE)

NB: formula on sheet1

Paul,

Care to re-iterate what you do have in Sheet1 and Sheet2? Which of these sheets houses the data you want to look in?

You appear to have concatenated 2 fields. In which sheet exactly & what is your typical lookup value?

If your data is not too huge, you can also dispense concatenation alltogether by using a different formula for lookup.

Aladin


[ This Message was edited by: Aladin Akyurek on 2002-05-19 08:40 ]

[ This Message was edited by: Aladin Akyurek on 2002-05-19 09:18 ]

[eliW]

Hi Paul,
1) your Table_Array must include your whole table range, therefore you have to put in your formula: Sheet2!A2:D100
2) If your range_lookup is TRUE, your first column in Table_Array must be sorted in ascending order.
Eli





[ This Message was edited by: eliW on 2002-05-19 08:47 ]

[Tommy Bak]

Hi Paul
Assuming that your concatcolumn on sheet2 is also C

=Vlookup(C2, sheet2!C2:X100, 5, 0)

where you have to replace X with your last column on sheet2 and replace 5 (which is column G) with the number of columns to the right of column C where you want to get the data (thatis: if you want to get data from sheet2 column F you replace 5 with 4.
regards Tommy

[Anne Troy]

You can download the sample MyVlookup at:

http://www.thewordexpert.com/downloads.htm

[jeh]

Dreamboat;

I just downloaded your example for vlookup;
Excellent example, I just learned something new!

Thanks,

Jim

[jeh]

Dreamboat;

I just downloaded your example for vlookup;
Excellent example, I just learned something new!

Thanks,

Jim