Compare two worksheets and update any empty cells

Not applicable

Table 1                                  Table 2

A                  B                       A              B

URN           Postcode           URN       Postcode

12345          DE34                12345       DE34

Blank Cell     BB35               34567       BB35

126788        FK45                126788      FK45


Hi, my goal is to search table 2 for postcode (column b) find a match and update table 1 column a based upon value in column a in table 2 IE table 1 URN Column A Row 2 would be populated with 34567. 


I have tried vlookup and a few other bits im not sure can anyone suggest a  formula and give examples?



1 Reply



In this case, VLOOKUP won't work, because the lookup value isn't in the leftmost of the table array, this a limitation in VLOOKUP.


So, you can use INDEX/MATCH which is the best alternative.





Please find the attached file.