Possible Formulas (IF or VLOOKUP??)

**kmarees1986** · 11-23-2011, 08:00 AM

Hi All,

I am tearing my hair out trying to figure this out and it seems so simple!!

I want my value in column C to automatically input the value from another column if another 2 different columns match.

Basically, in column A I have store numbers, and I also have the same store numbers in another spreadsheet - which I have pasted as a new worksheet int he same workbook. I want my formula to find the store number from column a, in the store number column on the next sheet and insert the value of the post code next the the store number.

=PostCode if column a and column x match??

Thanks,

Kristy

**Domski** · 11-23-2011, 08:04 AM

Hi,

Something like:

=VLOOKUP(A1,Sheet2!$A$1:$B$20,2,FALSE)

Where A1:B20 hold the store numbers and post codes on Sheet2.

Dom

**kmarees1986** · 11-23-2011, 08:10 AM

Thats done it!! Thank-you so much, there are 3694 post codes on my list, you have saved me a good few hours!!

Thanks again :-)

**Fotis1991** · 11-23-2011, 08:10 AM

Hi

INDEX & MATCH

See the attached

**Domski** · 11-23-2011, 08:20 AM

No problem. If you're happy with the response please mark the thread solved.

If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

Dom