If & Vlookup Formula

[Redseaweed7]

Hi,

I'm new to this forum. I having trouble with the following:

I have 3 tabs: N101, S101, and Report.

N101 looks like this and are all Type "10"'s:

10101010101 $20,000.00
10101010102 $40,000.00
10101010103 $60,000.00
10101010104 $80,000.00
10101010105 $100,000.00
10101010106 $120,000.00
10101010107 $140,000.00
10101010108 $160,000.00
10101010109 $180,000.00
10101010110 $200,000.00

S101 looks like this and are Type "2"s and "0"s.

2100101 $1,000.00
2100102 $2,000.00
2100103 $3,000.00
2100104 $4,000.00
2100105 $5,000.00
100106 $6,000.00
100107 $7,000.00
100108 $8,000.00
100109 $9,000.00
100110 $10,000.00


On my report, the types are mixed... These are the formulas I came up with. I need to combine the below formulas together but I can't even get each individual formula to work.
=IF(A2="10",VLOOKUP(B2,'N101'!$B:$C,2,FALSE))
=IF(A2="2",VLOOKUP(B2,'S101'!$B:$C,2,FALSE))
=IF(A2="0",VLOOKUP(B2,'S101'!$B:$C,2,FALSE))

Please. Help. Me.

[Aardigspook]

Welcome to the forum.
Try something like this:

Please Login or Register  to view this content.

Looking for "0" will only work if the cells (A2) are formatted as Text, as otherwise Excel will strip off leading zeros.

[ConneXionLost]

Deleted. I didn't notice you had problems with the individual formulas.