VlookUp

[jBailey031285]

I am trying to do a vlookup and cant seem to remember the formula

[JieJenn]

Use Match Index. Enter it with by hitting Ctrl + Shift + Enter

=INDEX('Phys Master'!$C$2:$C$11,MATCH(B8&A8,'Phys Master'!$A$2:$A$11&'Phys Master'!$B$2:$B$11,0))

C2:C11 is the field where the result is coming from.

[jBailey031285]

I am having problems getting that to work I want to make sure that on actual - specialty column b matches column a phys master

[dilipandey]

Hi JBailey,

See the attached file where I have vlookup -ed all the three columns from target tab. Let me know if this helps.

Regards,
DILIPandey

<click on below 'star' if this helps>

[dilipandey]

Hi Jbailey,

Have you looked at my post #3?

Regards,
DILIPandey

<click on below 'star' if this helps>

[jBailey031285]

I have but dont understand it

[JieJenn]

I tried to make this as easy as possible.

[jBailey031285]

JieJenn do you have a email I can email you this whole file it is too big and I continually get a #value error

[dilipandey]

Hi jbailey,

I believe you need to describe first if you want to lookup value basis one column or basis two columns :-

MP28

or

0001 MP28

and then you need to tell which column you need from Phys Master ?

regards,
DILIPandey

<click on below 'star' if this helps>

[jBailey031285]

I want to see if column a&b on actual-specialty are equal to columns a&b on phys master if not I want it give me a error

Here is the formula for column d and column e (and it is returning #value error

=INDEX(PhysMaster!$A$2:$A$841,MATCH(B8&A8,PhysMaster!$B$2:$B$841&PhysMaster!$A$2:$A$841,0))

Column E
=INDEX(PhysMaster!$B$2:$B$841,MATCH(A8&B8,PhysMaster!$A$2:$A$841&PhysMaster!$B$2:$B$841,0))

[jBailey031285]

It says I am using the wrong data type for the numeric values should I used number or general? And for the ones mp28 which data type?

[dilipandey]

I want to see if column a&b on actual-specialty are equal to columns a&b on phys master if not I want it give me a error

HI jbailey, above is what i have already provided in my post#3, see that where you'll find one error as that data combination do not match. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[jBailey031285]

Ok but I changed all the data combo to general and it still not working

[dilipandey]

Ok...
Upload the file having changed data in it. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[jBailey031285]

Here is the file. thanks for your help

[dilipandey]

Ok.. and what result you wanted to see in place of #VALUE! in sheet 2 ?


Regards,
DILIPandey

<click on below 'star' if this helps>

[JieJenn]

Instead of hitting enter, you need to hit CTRL + SHIFT + ENTER together

[jBailey031285]

If it matches I would like to see true if not I want to see false is that possible?