Previous Topic Next Topic

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.


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

Compare values in two columns and return the value from third
ramdubai -
keshav -

11 responses
VlookUp Problem?
akram786 -
Mazzaropi -

1 response
Automatically transfer data from one sheet to another
sunny49er -
TrowaD -

22 responses
Concanating text using vlookup forumula
gannesh0604 -
gannesh0604 -

0 responses
Conditional Formatting in a vlookup
attycuz -
TrowaD -

1 response