Lookup Question and Formula

[JimS]

In sheet2 from x3:ba3 are a row of numbers calculated from a table.
The numbers are listed in alphabetical order according to name.

So the row might look like this:

bob don ed mike steve
29 80 36 104 22

In sheet3 I have a column of names (changes every day).

bob
don
steve
ed
mike

Now I need a formula so when I type in the names on Sheet3 I want the
corresponding numbers from Sheet2 to go next to the name:

bob 29
ed 36
mike 104

etc.

Is that Vlookup, Hlookup, match or what exactly?

Thanks

 

[muddan madhu]

=HLOOKUP(A1,Sheet3!X3:BA4,2,0)

 

[JimS]

That is too cool. Thanks, Amigo!

=HLOOKUP(A1,Sheet3!X3:BA4,2,0)

 

[JimS]

One question. I put in this formula to gather the corresponding
numbers in the column of the table:

=IF(F157="","",VLOOKUP(F157,'bob'!$V$4:$W$33,22,0))

But it didn't work. I assumed you would use the column index number
corresponding to the V column, which is 22, but when I inserted the
number 2 it did work. How come? What am I missing?

Got to thinking. Does it refer to column 2 "of the table?"

Thanks again.

 

[Pete_UK]

Yes, it does. Your table array in the formula is two columns wide,
i.e. from V to W, so your column_ref parameter can only be 1 or 2 in
this instance - it is relative to the table.

Hope this helps.

Pete

 

[herochenna]

Visit www.ExcelGoodies.Com

 

[herochenna]

Visit www.ExcelGoodies.Com