Vlookup or if

Closed

Gemma` - Aug 5, 2016 at 06:00 AM
fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 - Aug 6, 2016 at 07:05 PM

Hello,

I really hope you can help. I have become very rusty on Excel.

I am trying to create the formula where one cell content is checked against another and if it is correct then the content of another cell is entered.

Example is

5001 YA65
5002 YA16
5003 PO59
5004 PE10
5019 PK09
5020 PK09
5022 MJ11
5023 MJ11
5024 MJ11

I am checking column 2 against another spreadsheet but i want column 1 to be the outcome.

Vlookup or if
Vlookup date 1/0/1900 ✓ - Excel Forum
Transfer data from one excel worksheet to another automatically vlookup - Guide
Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
Automatically transfer data from one sheet to another ✓ - Excel Forum

1 response

Answer 1 / 1

fdibbins Posts 33 Registration date Sunday June 19, 2016 Status Contributor Last seen November 20, 2016 1
Aug 6, 2016 at 07:05 PM

Perhaps this?
5001 YA65
5002 YA16 Find PO59
5003 PO59 Ans 5003
5004 PE10
5019 PK09
5020 PK09
5022 MJ11
5023 MJ11
5024 MJ11

Ans=INDEX($A$1:$A$9,MATCH(E2,$B$1:$B$9,0))

Similar discussions

Match partial text string in one sheet to another text string in another sheet

Compare values in two columns and return the value from third

Concanating text using vlookup forumula

Conditional Formatting in a vlookup

Find missing data in 2 columns (Excel)

Similar discussions

Subscribe To Our Newsletter!