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
Transfer data from one excel worksheet to another automatically vlookup - Guide
Vlookup if cell contains a word within text ✓ - Word Forum
Vlookup if two cells match return value from third ✓ - Excel Forum
Vlookup false ✓ - Excel Forum
Help Please IF & VLOOKUP Returns - 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

Comparing columns and returning value

Lookup partial text contained in cell range

Using Vlookup to return insted of 00/01/1900

add/subtract & vlookup formula

Similar discussions

Subscribe To Our Newsletter!