another lookup question
Posted by nmn on September 28, 2001 8:22 AM
I have the same type question as Jose. One worksheet contains:
Fuse/Amps Resistance
Amperes (Ohms)
5A/5A 0.092
5A/10A 0.084
25A/20A 0.023
25A/30A 0.012
4A Fuse 0.917
2A Fuse 0.952
W/5A/5A 0.193
in cells A1:B9, with data in cells A3:B9 on worksheet, Tallies.
My formula on another worksheet is:
=LOOKUP(W77,Tallies!$A$3:$A$9,Tallies!$B$3:$B$9)
However, typing 5A/5A in W77 returns 0.952 instead of
0.092. Other values in W77 return #N/A. Any ideas how
to solve this problem?
Posted by Aladin Akyurek on September 28, 2001 8:45 AM
Try:
=IF(COUNTIF(W77,Tallies!$A$3:$A$9,W77),VLOOKUP(W77,Tallies!$A$3:$B$9),"")
Aladin
Posted by Juan Pablo on September 28, 2001 8:52 AM
Aladin's formula is lacking one last thing
=IF(COUNTIF(W77,Tallies!$A$3:$A$9,W77),VLOOKUP(W77,Tallies!$A$3:$B$9,2,0),"")
Juan Pablo
-----------------
=IF(COUNTIF(W77,Tallies!$A$3:$A$9,W77),VLOOKUP(W77,Tallies!$A$3:$B$9),"")
Posted by Aladin akyurek on September 28, 2001 8:57 AM
Yep. Thanks, Juan. Typing/copying too fast is the culprit. 's formula is lacking one last thing
