Hello all! I've received a spreadsheet from two different vendors. Naturally, they have different UPC codes- but for the ones that match I'd like to compare the listed price on each spreadsheet and use the "if" function to determine the cheaper vendor. I have tried using VLookup with no avail. Can someone please lead me in the right direction? Sifting through google isn't working...
For example,
A B C D E
1 200 (prices) (description)
2 201
3 204
4 209
5
6 211
A B C D E
1 201
2 203
3 204
4 205
5 209
6 211
Bookmarks