Pull Data from excel sheet

A

aussiebloke72

New Member
Joined
Jan 10, 2024
Messages
6
Office Version
  1. 2016
Platform
  1. Windows
Aesop.xlsx

Hi I need the numbers that are in column c on sheet 2 to match up with the right
poec numbers on sheet 1 I have tried VLook up formula but doesn't seem to work.
thank you.

Wayne
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Sort by date Sort by votes
Hi Alexa thanx I will this is the formula I have been using doesn’t seem to work but I will try it gain today thanx you
 
Upvote 0
Alex Blakenburg said:
Try this:
Excel Formula: 
=VLOOKUP(B2,Sheet2!$B$2:$C$32,2,FALSE)
Click to expand...
Alex I think I said it wrong in the description so I need the numbers in the second last column on sheet 2 to populate in the priority column of sheet 1 and match up with the corresponding poec numbers
 
Upvote 0
It would help if we could see your data. Second last column out of how many?
 
Upvote 0
No problem, then try
Excel Formula: 
=VLOOKUP($B2,Sheet2!$B$2:$L$32,11,FALSE)

You could expand that to the below:
Excel Formula: 
=IFERROR(VLOOKUP($B2,Sheet2!$B$2:$L$32,11,FALSE),"Not Found")
 
Upvote 0
@Asbestos_Jen

Sheet1
20240110 VLookup Aesop aussiebloke72.xlsx
ABCDEFGHIJKLMNO
1ItemPurchase DescriptionP/O NumberQuantityItemQuantityReceived Priority SequenceOriginal Delivery DateExpected Delivery DateSZ comment 20/12Ship Date From TIW Tiw Comments
221/11/2023POECFM009473The Ingredient Warehouse Pty LtdWB01BM18WB01BM18 EO Preblend P&F10005/01/20248/01/2024Not Found#N/ACan this 100 and at least 40 on POECFM009577 5/01/2024COMPLETED SENT 5TH OF JAN 24
321/11/2023POECFM009474The Ingredient Warehouse Pty LtdWBBM13MBBM13 EO Preblend P&F18005/01/20248/01/202425/01/2024COMPLETED SENT 5TH OF JAN 25
421/11/2023POECFM009475The Ingredient Warehouse Pty LtdWBBM07MBBM07 EO Preblend P&F36005/01/20248/01/20242#N/A5/01/2024COMPLETED SENT 5TH OF JAN 26
521/11/2023POECFM009478The Ingredient Warehouse Pty LtdWBBT11MBBT11 EO Preblend P&F18005/01/20248/01/20244#N/A5/01/2024COMPLETED SENT 5TH OF JAN 27
621/11/2023POECFM009479The Ingredient Warehouse Pty LtdWBHR16MBHR16 EO Preblend P&F2005/01/20248/01/20241#REF!5/01/2024COMPLETED SENT 5TH OF JAN 28
721/11/2023POECFM009482The Ingredient Warehouse Pty LtdWBSK60MB02SK60 EO Preblend P&F805/01/20248/01/20247#N/A5/01/2024COMPLETED SENT 5TH OF JAN 29
814/08/2023POECFM009014The Ingredient Warehouse Pty LtdWBHR16MBHR16 EO Preblend P&F402018/09/20239/01/202435/01/2024COMPLETED SENT 5TH OF JAN 30
912/12/2023POECFM009551The Ingredient Warehouse Pty LtdWBSK35MB01SK35 EO Preblend P&F108/01/20249/01/2024616/01/2024COMPLETED SENT 5TH OF JAN 31
Sheet1
Cell Formulas
RangeFormula
L2L2=VLOOKUP(B2,Sheet2!B3:L32,Sheet2!L:L,FALSE)
L4:L5,L7L4=VLOOKUP(B4,Sheet2!$A$2:Sheet2!$M$32,11,FALSE)
L6L6=VLOOKUP(#REF!,Sheet2!$A$2:Sheet2!$M$32,11,FALSE)
K2K2=IFERROR(VLOOKUP($B2,Sheet2!$B$2:$L$32,11,FALSE),"Not Found")
K3:K9K3=VLOOKUP($B3,Sheet2!$B$2:$L$32,11,FALSE)
Cells with Data Validation
CellAllowCriteria
O2ListCOMPLETED SENT 5TH OF JAN 24,To be delivered 16.01.24,To be delivered 22.01.24,To be delivered 5.02.24,To be delivered 12.02.24,To be delivered 19.02.24
O3:O9ListCOMPLETED SENT 5TH OF JAN 24


Sheet 2

20240110 VLookup Aesop aussiebloke72.xlsx
ABCDEFGHIJKLM
1DateP/O NumberItemPurchase DescriptionQuantityReceivedOriginal Delivery DateExpected Delivery DateDelivery LocationStatusPriority SequenceSZ comment 20/12
2 1WB01BM18WB01BM18 EO Preblend P&F10005/01/202419/09/2023DC (EC)Pending Receipt1Can this 100 and at least 40 on POECFM009577 be made by W/C 8/01
321/11/2023POECFM0094791WBHR16MBHR16 EO Preblend P&F2005/01/20248/01/2024DC (EC)Pending Receipt1
421/11/2023POECFM0094742WBBM13MBBM13 EO Preblend P&F18005/01/20248/01/2024DC (EC)Pending Receipt2
521/11/2023POECFM0094752WBBM07MBBM07 EO Preblend P&F36005/01/20248/01/2024DC (EC)Pending Receipt2
614/08/2023POECFM0090143WBHR16MBHR16 EO Preblend P&F402018/09/20238/01/2024DC (EC)Partially Received3
721/11/2023POECFM0094784WBBT11MBBT11 EO Preblend P&F18005/01/20248/01/2024DC (EC)Pending Receipt4
821/11/2023POECFM0094835WBBT15MBBT15 EO Preblend P&F40025/12/20238/01/2024DC (EC)Pending Receipt5
913/12/2023POECFM0095695WBBD20MB02BD20 EO Preblend P&F40015/01/20249/01/2024DC (EC)Pending Receipt5
Sheet2
 
Upvote 0
Alex Blakenburg said:
Try this:
Excel Formula: 
=VLOOKUP(B2,Sheet2!$B$2:$C$32,2,FALSE)
Click to expand...
Alex I think I said it wrong in the description so I need the numbers in the second last column on sheet 2 to populate in the priority column of sheet 1 and match up with the corresponding poec
Alex Blakenburg said:
No problem, then try
Excel Formula: 
=VLOOKUP($B2,Sheet2!$B$2:$L$32,11,FALSE)

You could expand that to the below:
Excel Formula: 
=IFERROR(VLOOKUP($B2,Sheet2!$B$2:$L$32,11,FALSE),"Not Found")[/CODe
[/QUOTE]
Click to expand...
 
Upvote 0
Thanx got it to work i think it was more my sheet wasn’t configured properly rather than the code not working thank you for your help
 
Upvote 0
You must log in or register to reply here.

Similar threads

F
  • Solved
Vlook-up two criteria in two sheets
Replies
3
Views
282
RobP
R
S
  • Question Question
Formula for Pulling Data From Sheet 2 Based on Cell Value in Sheet 1
Replies
1
Views
168
Kaper
Kaper
D
  • Question Question
Count unique dates with criteria - Excel 365
Replies
3
Views
305
DK27
D
D
  • Question Question
pull info from a sheet using 2 different pull down lists
Replies
0
Views
45
dkw1
D
L
  • Solved
Insert formulas to new lines in table
Replies
3
Views
152
Ltuk85
L

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,633
Latest member
DougMo

Share this page

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