Link cells to pull specific data

[NM]

Hi,

Spreadsheet 1 has column B with Network number, C with Name, D with
Description.

In spreadsheet 2 , in column A i will put Network number and I want the Name
and Description from Spreadsheet 1 to be pulled into Sheet 2 in columns B&C.

Please let me know.

Thanks for your help.

 

[Shane Devenshire]

Hi,

Looks like
=VLOOKUP(A2,Sheet1!B1100,2,False)
and
=VLOOKUP(A2,Sheet1!B1100,3,False)

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[NM]

Thanks Shane! I am grateful to you for your help.

 

[NM]

Hi Shane,

I'm using the same Vlookup formula in a different sheet. i'm getting a #N/A
error! The calculation steps show erroe at the 'lookup_value'.I've tried by
best but cannot work through it.Can you please let me know how to get rid of
this.

Thanks!

 

[John C]

Are any of the network numbers atually text and not real numbers? You could
test it by finding the 2 cells that should match and just seeing if they
actually do, for example:
Sheet1!B7 is a network number that you know should match to Sheet3!A5
so test it, somewhere in the workbook type:
=(Sheet1!B7=Sheet3!A5) ... note, if you test it on sheet1 or sheet3 you do
not need to reference it in the formula
You could then also test for numbers
=ISNUMBER(Sheet1!B7)
=ISNUMBER(Sheet3!A5)