Help with lookup...over my head, under my feat

[Rossco]

Hey, Im pretty new to all this excel stuff, looking for help with lookups. I currently have A1 to A112....to F1 to F112 filled out. I need a way for a user to lookup any "A" value so it will give the corresponding answer from "B" to "F"...ie, he/she enters "1000", then, it should give them 5 different results, any help would be greatly appritiated, thanks..

[BenjieLop]

Hey, Im pretty new to all this excel stuff, looking for help with lookups. I currently have A1 to A112....to F1 to F112 filled out. I need a way for a user to lookup any "A" value so it will give the corresponding answer from "B" to "F"...ie, he/she enters "1000", then, it should give them 5 different results, any help would be greatly appritiated, thanks..

If your value to be looked up is entered in Cell G1, the formula

=vlookup(G1,$A$1:$F$112,2,0)

will give you the corresponding value from Column B.

To get the corresponding value from Column C, replace the argument "2" in the above formula with "3"; for corresponding value from Column D, replace 2 with 4;
for values from Column E, replace 2 with 5 and for values from Column F, replace 2 with 6.

Hope this is what you are looking for.

Regards.