Excel Question?

Question

If column A column B
LNX234 185456
ALP154 201458
HRG159 213610

If the Item# equals the SKU (column A = column B), is there any way I can just type the SKU# and the Item# automatically pop up without using the "find" function and doing it one by one?

Answer 1

One way would be to add a third column in which either a 0 or 1 is placed depending on a match

Column C formula = IF(A1=B1,1,0) copy this formula down the entire list

Now you will have a column of 1's and 0's where a 1 indicated a match between column A & column B

Do a decending sort on Column C and all of the matching data will be brough to the top of the sheet.

Answer 2

Use the VLookup inside the if condition. Say you have data in Col A and B from Row 1 to 100, use this formula in Cell C1 - C100:

Use this if you want to look up Col A and get corresponding value from Col B
If (Ax = Bx, VLookup (Ax, A1:B100, 2, false), "")

Use this if you want to look up Col B and get corresponding value from Col A
If (Ax = Bx, VLookup (Bx, A1:B100, 1, false), "")

~HTH