Vlookup or if

Closed
Report
-
Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
-
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.


1 reply

Posts
33
Registration date
Sunday June 19, 2016
Status
Contributor
Last seen
November 20, 2016
1
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))