-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
bay
-
L
Searching text to see if it contains a value then returning a value
If cell A1 contains information from and cell in column C return value in column D at the same row as information. <tbody> Woolworths W7001 Sandy Bay 2004 United 2001 Dr Jay 2002 Sandy Bay Newsagent 2003 W7001 2004 Coles 2005 </tbody> Thanks for your help!- levy77
- Thread
- bay cell information sandy w7001
- Replies: 8
- Forum: Excel Questions
-
B
Can you create new rows based on the number value in a column
So here is the situation that I am faced with making work. We have a cell where when someone puts a number (1-10) it should create new rows labeled (A-J) based on the number in the cell. <colgroup><col><col><col></colgroup><tbody> Rack ID (left side bay if possible) Number of levels (0-10)...- baionia
- Thread
- bay cell left number work
- Replies: 2
- Forum: Excel Questions
-
H
IF, AND, VLOOKUP into the future...
Hello, I'm new here and I've been scouring this forum and the web for a solution to my scheduling conundrum....I have workshop and I want to be able to know what areas will be busy in the coming weeks/months, based on the current demand. So, I have a table where I input new jobs and I want...- Humber
- Thread
- bay date highlight cell schedule vlookup & if & and
- Replies: 3
- Forum: Excel Questions
-
S
VLOOKUP to check 2 lists?
Hi, I would like to search the 2 lists below for a specific trailer number and return the bay number. Is it possible to search both lists? <colgroup><col><col><col><col><col><col><col></colgroup><tbody> TRAILER PARK 1 TRAILER PARK 2 Trailer Bay Trailer Bay TEST 1 TP1 1 TP2...- sknight22
- Thread
- bay lists tp1 tp2 trailer
- Replies: 1
- Forum: Excel Questions
