Jafro said:How do I do a vlookup on a table that is on another excel sheet?
IE What is the formula to go to the other sheet and return the proper answer
Thanks Jafro
Jafro said:Brian:
I tried the one you gave and it does not work. Here is some more info
Look at the result in D30 in the sheet "house" and find in the sheet (in the same wookbook) "tables"
The table is located between cells AB5 and AC45
From this info can you give me the formula?
Thanks Jafro
Jafro said:Sorry for the confusion. I will try again
Workbook called "Servicecalc"
Worksheet inside "Servicecalc" called "House"
Another worksheet inside "Servicecalc" called "Tables"
eg. of "Tables" This sheet contains 7 different tables of numbers
Table #1 in "Tables"
AB AC
5 =15 5 = 17
6 =20 6 = 19
7 =30 7 = 25
8 =40 8 = 35
9 =50 9 = 45
The value in cell D30 is compared to the value in AB5 to 9 and the corresponding value in AC5 to9 is returned to cell D30
Hope this helps
jafro