Thank you for your help, I can finally finish this worksheet. I really
appreicate it.
"Aladin Akyurek" wrote:
If the data area is in ascending order on its first column as it looks
from your sample...
=LOOKUP(E2,$A$2:$A$6,$B$2:$B$6)
=VLOOKUP(E2,$A$2:$B$6,2,1)
If the data area is not sorted...
=VLOOKUP(E2,$A$2:$B$6,2,0)
pugsly8422 wrote:
I have 2 lists and now thanks to help on here I can refrence the list the way
I need to, now I've realized I need to be able to put in one number and get a
totally different one. Here is the example
1 10
2 17
3 23
4 31
5 34
The numbers are in seperate columns. One of the numbers on the left will be
entered and I need it to come back with the corresponding number on the right.
Thanks again for your help.
|