i need the value of a cell by comparing another two cells in a list
but in v lookup it compares single cell i need 2 cell .
i am having a list material codes and for each material code more than 2 suppliers are there
each will supply material in different dates .
i need the corresponding receipt date by comparing material code & supplier code for a list of material codes.
in vlookup v have the option compare one filed. but i need 4 2 fields.
this has nothing to do with random or non random order. how did you get A 2 as not available (#N/A).
in my computer it is --------------dd
of course my version is excel 2002. still it should work in a future version. see whetehr there are any typo in sheet 2
when you type A and 2 are there any extra space. delete A and 2 and retype again. and get the formula.