Bopo2
11-08-2009, 10:54 AM
Hey guys
Basically I have a vlookup formula which simply returns data based on the input in A1 (an ID number)
=VLOOKUP(A1, CustomerRecords, 2,FALSE)
However the user might know the name of customer, and not the ID, therefore I want another optional cell which will still lookup the data, however I don't know if it's possible to do this all in 1 cell, he's some pseudo style code:
=IF A1 <> "" =VLOOKUP(A1, CustomerRecords, 2,FALSE) else
=VLOOKUP(B1, CustomerRecords, 1,FALSE)
Wait... that doesn't make logical sense either really, hopefully you understand what I'm trying to achieve :doh:
Basically I have a vlookup formula which simply returns data based on the input in A1 (an ID number)
=VLOOKUP(A1, CustomerRecords, 2,FALSE)
However the user might know the name of customer, and not the ID, therefore I want another optional cell which will still lookup the data, however I don't know if it's possible to do this all in 1 cell, he's some pseudo style code:
=IF A1 <> "" =VLOOKUP(A1, CustomerRecords, 2,FALSE) else
=VLOOKUP(B1, CustomerRecords, 1,FALSE)
Wait... that doesn't make logical sense either really, hopefully you understand what I'm trying to achieve :doh: