Vlookup

[LeeBillington]

Hey guys,

So i am stuck.

I have input this formula

=IF(C6="","",VLOOKUP(C6,Data!$E$2:$E$398,5,FALSE))

And i basically want it to return what is written in the cell i am asking for. Say for example it says.. "chicken"

Any ideas how or where i am going wrong?

Obviously i am still learning!

 

[AliGW]

OK, then you need an array formula for that. Are you able to provide some sample data? Grab yourself the ForumTools add-in in my signature line and install it to help you get some stuff into your next post in a copyable format.

 

[LeeBillington]

I am confused, sorry I don't know what you mean?

I've downloaded it but what now? ha ha.. amateur right here.

 

[AliGW]

Which bit do you not understand?

1. Please provide a table of sample data for me to work with so that I can construct an appropriate array formula for you to do what you want (VLOOKUP will only ever return the first result it finds).
2. As you can't post an attachment here, please follow the ForumTools link in my signature line (below) and get yourself the ForumTools add-in. Install this in your version of Excel and use it to extract some data from your workbook to paste into your nwxt post.

Is that clearer now?

 

[LeeBillington]

Report​

Excel 2007 32 bit
	C	D	E
21
Report

Cell Formulas
Range	Formula
I1	=TODAY()
J1	=TEXT(I1,"DDDD")
K1	=NOW()
F6	=IF(C6="","",VLOOKUP(C6,Register!$A$3:$E$398,5,FALSE))
F10	=IF(C6="","",VLOOKUP(C6,Register!$A$3:$D$398,4,FALSE))
C8	=IF(C6="","",VLOOKUP(C6,Register!$A$3:$C$398,2,FALSE))
C10	=IF(C6="","",VLOOKUP(C6,Register!$A$3:$C$398,3,FALSE))
C16	=IF(C6="","",VLOOKUP(C6,Data!$A$2:$E$398,5,FALSE))
C17	=IF(C6="","",VLOOKUP(C6,Data!$A$2:$E$398,5,FALSE))
C18	=IF(C6="","",VLOOKUP(C6,Data!$A$2:$E$398,5,FALSE))
C19	=IF(C6="","",VLOOKUP(C6,Data!$A$2:$E$398,5,FALSE))
C20	=IF(C6="","",VLOOKUP(C6,Data!$A$2:$E$398,5,FALSE))
B13	=IF(C6="","",VLOOKUP(C6,Register!$A$3:$G$398,7,FALSE))
B16	=IF(C6="","",VLOOKUP(C6,Data!$A$2:$C$398,3,FALSE))
D13	=IF(B13="","",DATEDIF(B13,I1,"Y")&" Years, "&DATEDIF(B13,I1,"YM")&" Months, "&DATEDIF(B13,I1,"MD")&" Days")

Is this what you wanted? im not sure.

<tbody>
</tbody>

 

[AliGW]

Thanks, but that makes not sense to me. What should be in those empty cells? What I really need to see is the layout of the table from which you want to extract and list data, then I can construct the right formula for you.

 

[AliGW]

I have to go offline now for a while. I'll look in again later and see if I can help, if nobody else has stepped in.

 

[LeeBillington]

So Ill do a little table here for you

so in the sheet 'data' on column 'A' Will be all numbers ranging from 0001-9000 and in Column 'E' from E2:E900 will be Items

So for example.. In 'A2' number 2351 lost an item, the item that is in E2 corresponding to that number
And in A3 Number 3677 lost an item, the item in E3 that is linked to that number too
but then 2351 lost an item again, In E4

but when i type in '2351' in C6.. on the first sheet. i want it to show all items lost by 2351 In the sheet 'Data'

It Sounds confusing.. just imagine the numbers as people



I need to type in 2351 and it to show everything linked to 2351 in one area.

So like..

2351 - Chicken
2351 - Mangos
2351 - Juice
2351 - Mushrooms