vlookup from either of 2 worksheets

[hsandeep]

My INPUT data is in 2 worksheets. Sheet1 & Sheet2.
Output is Sheet3.
In Sheet3, I want to perform vlookup & get data of Sheet1 IF EXISTING else data of Sheet2.
Ex;
Sheet1: A1=#N/A
Sheet2: G1=500
Sheet3: B1=500

How to achieve?

 

[Aladin Akyurek]

My INPUT data is in 2 worksheets. Sheet1 & Sheet2.
Output is Sheet3.
In Sheet3, I want to perform vlookup & get data of Sheet1 IF EXISTING else data of Sheet2.
Ex;
Sheet1: A1=#N/A
Sheet2: G1=500
Sheet3: B1=500

How to achieve?

Your specs are incomplete...

Sheet3, B1

=IFERROR(LOOKUP(9.99999999999999E+307,CHOOSE({1,2},VLOOKUP(A1,Sheet2!F:G,2,0),VLOOKUP(A1,Sheet1!F:G,2,0))),"")

 

[hsandeep]

To complete,
Sheet1: A1 PPP & G1=#N/A
Sheet2: A1 PPP & G1=500
Sheet3: A1 PPP.
So in B1, 500 is answer.

 

[Aladin Akyurek]

To complete,
Sheet1: A1 PPP & G1=#N/A
Sheet2: A1 PPP & G1=500
Sheet3: A1 PPP.
So in B1, 500 is answer.

I'm sure your specs are clear to you, but not me. The topic title mentions vlookup, which ordinarily presupposes a table, that is, a multicell range. I don't see that you mention above any such table...

 

[hsandeep]

I am sorry. I'll try to make more clearer. Please bear with me.....
Sheet1: A1:A999 P1,P2,P3....P999
Sheet2: G1:G999 P1000, P1001, ....... P1999
So in Sheet3 in B1: for A1=P1 get X1 (from Sheet1) but if A1=P1000 get X1 (from Sheet2).

Ihope i have clarified.

 

[Aladin Akyurek]

I am sorry. I'll try to make more clearer. Please bear with me.....
Sheet1: A1:A999 P1,P2,P3....P999
Sheet2: G1:G999 P1000, P1001, ....... P1999
So in Sheet3 in B1: for A1=P1 get X1 (from Sheet1) but if A1=P1000 get X1 (from Sheet2).

Ihope i have clarified.

What is X1?

Taking up your Sheet2 spec literally...

=IFERROR(LOOKUP(9.99999999999999E+307,CHOOSE({1,2},
  INDEX(Sheet2!$P$1000:$P$1999,MATCH(A1,Sheet2!$A$1:$A$999,0)),
  INDEX(Sheet1!$P$1:$P$999,MATCH(A1,Sheet2!$G$1:$G$999,0)))),"")