guidelines on using match to compare two lists that are not the same height

Yes - I have no idea what you mean.

Cell G23 is trying to compare A23 to column D. But there is nothing in A23, so naturally it is returning #VALUE!

You should put your second match column in the other table. It doesn't really make any sense where it is.

Assuming I have the MATCH direction correct, the following works:

=MATCH([@[Cost Centre]],CostCentre[[#All],[Cost Centre]],0)

This matches the contents of column D with column A; for G23, looking at D23 it retruns 17, the relevant row from column A.

Thanks
Rob H

hi, what I am trying to get is the following...In Column 1 (D) what I want the formula to do is to look up the value in D3 (2111103), and then to look at the matching column in the table starting in a2 (called Cost Centre) and return the position/N/A if it's not there. I've amended the formula in Column F as per your suggestion and this now works as required i.e. it's showing up washing machine (1111111) as missing from the list N/A i.e. that it's not in the Cost Centre table.  Thank you :-)  Now in Column G (2nd comparison) I want it to do the same but in the other direction i.e. Look up a3, match to column D and return an N/A if there is no match. At the moment (see attached file) it's giving me an NA where I can see a match..e.g. 2111110 is in both lists but the Comparison 2 formula (as I have it) is showing N/A. Ditto with 2111118
EE-match-list-not-same-height-vers-02.xl

I've requested that this question be closed as follows:

Accepted answer: 500 points for Saurabh Singh Teotia's comment #a40670385

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Apologies for the delay. Thanks for your solutions..