Formula between Sheets

mirofa

New Member
Joined
Sep 21, 2024
Messages
8
Office Version
  1. 2019
  2. 2016
  3. 2013
  4. 2007
Platform
  1. Windows
Greetings. I'm new here and I don't have much time to read each post one by one. I will give you an example in text and I will leave photos under text.
I have two sheets. In the SHEET 2 I have columns A and B. In column A I have numbers (codes) and in the second column B names of those codes.
I want in SHEET 1 , column A , in any cell for example In the first 15 when I enter numbers (codes) from SHEET 2 that it automatically recognizes name of that number (codes) from SHEET 2.
So that I don't have to manually type the name every time after i write number ( codes) . Note: Each number (code) is different and each of them has a different name.
Is that possible and thanks in advance.
 

Attachments

  • Screenshot_1.jpg
    Screenshot_1.jpg
    67.6 KB · Views: 8
  • Screenshot_2.jpg
    Screenshot_2.jpg
    62.5 KB · Views: 9

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Hi mirofa,

Welcome to MrExcel!!

Put this formula into cell B1 of SHEET 1 and copy down as far as need:

Excel Formula:
=IFERROR(VLOOKUP(A1,'SHEET 2'!A:B,2,FALSE),"")

Hope that helps,

Robert
 
Upvote 1
Excel Formula:
=IFERROR(VLOOKUP(A1,'SHEET 2'!A:B,2,FALSE),"")

It shows me this error. I'm trying to create a packing slip. I'll try to explain better. In Sheet 2 I have product codes and names. And when I enter the product code in sheet 1 for example in cell B2 or B3 , I want it to immediately write the name of the product that is related to that code in the column next to it, so that I don't have to manually enter names every time. Look at new pictures.

thank you
 

Attachments

  • Screenshot_1.jpg
    Screenshot_1.jpg
    28.5 KB · Views: 7
  • Screenshot_5.jpg
    Screenshot_5.jpg
    61.5 KB · Views: 7
  • Screenshot_6.jpg
    Screenshot_6.jpg
    142.6 KB · Views: 7
Upvote 0
It may be a regional settings issue - perhaps you normally use semicolons rather than commas as argument separators? Try:

Excel Formula:
=IFERROR(VLOOKUP(A1;'SHEET 2'!A:B;2;FALSE);"")
 
Upvote 1
It may be a regional settings issue - perhaps you normally use semicolons rather than commas as argument separators? Try:

Excel Formula:
=IFERROR(VLOOKUP(A1;'SHEET 2'!A:B;2;FALSE);"")
I solved it. Thank you very much.
 
Upvote 0

Forum statistics

Threads
1,223,214
Messages
6,170,772
Members
452,353
Latest member
strainu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top