I have a table where I have my list and it is in a deferent work sheet. When
a user selects something from the list I want to match it with my table and
return a number in a different cell. I have tried this formula.
=IF(D5="","",VLOOKUP(D5,Table!A:B,2,FALSE)) It will work for this cell now I
want to return a different number in column C I try to change B to C but it
only returns the number in B. What do I need to do?
Thanks for the help