Populating Excel Cells

[DMT Dave]

Hi Guy's, hope you are all well, are you guy's able to tell me how to populate Excel cells, i know this is Access Forum but I have never tried worked in Excel code, just Access only by inputting data to Excel and extracting data from Excel...

The limited use i have with Excel is generating combo (data validating) based on 1 column, although this file uploaded is not relevant to a project, it is just a F1 calendar file i am playing with to test

so column G is validated to column B

how can I make column H = column C based on selection from G ???

unlike access where column count in a combo and populate a column number (0) or (1) etc.....

So:

if i was to select Australia then column H would be: Melbourne Grand Prix Circuit
if i was to select Japan then column H would be: Suzuka International Racing Course

i guess I'm asking how to make the drop down list have the data in there and pass to another cell ?, done some google searching but never worked with Excel code....



Once i can do this, i can then hide columns B and C and use list box (combo as I know it)

Thanks for any help you can give

[Welshgasman]

No code involved.
Use Data Validation for your combo on the country column.
Use VlookUp() to get the circuit name.

However as they never change, and you have them anyway, why?

[DMT Dave]

Thanks WGM, this only a test file so what i am trying to see if possible, like Access add 2 fields to a combo column 0 and 1

column 0 would be equivalent to column B on the excel and column 1 would be equivalent to column C

Not sure if Excel is similar, i can't validate 2 columns to 1 column on Excel, like mentioned, never worked with Excel code, this is also just a test file.

So in the list, if i chose what is row 9 which would be Monaco, then i am trying to tell column H to be Circuit De Monaco from row 9 (column C)

I don't know if possible for a listbox to look up values in column C from row 9 if row 9 was selected then put that data to another cell

hope i have made sense

[ArviLaanemets]

2 example variants for 2 source designs, to give some example how it may work in Excel

[Welshgasman]

Thanks WGM, this only a test file so what i am trying to see if possible, like Access add 2 fields to a combo column 0 and 1

column 0 would be equivalent to column B on the excel and column 1 would be equivalent to column C

Not sure if Excel is similar, i can't validate 2 columns to 1 column on Excel, like mentioned, never worked with Excel code, this is also just a test file.

So in the list, if i chose what is row 9 which would be Monaco, then i am trying to tell column H to be Circuit De Monaco from row 9 (column C)

I don't know if possible for a listbox to look up values in column C from row 9 if row 9 was selected then put that data to another cell

hope i have made sense

The logic still applies?
I use the same logic for my community work.
I select a passenger from a lookup where the data is on another sheet.
Then other columns are populated with distance, whether they have a blue badge or not, my phone number or not, and any notes.

Pretty much db logic, store it once and bring it up as needed.

[DMT Dave]

Thanks guy's will go into this, thanks again

[DMT Dave]

Thanks guys, i am looking at example now and taking note of the method =INDEX(Data1!$C$2:$C$5,MATCH($B$13,Data1!$B$2:$B$5 ,0))

This helps massively because i can work this out i think

Thanks again

[Welshgasman]

I use simple VlookUp()s

[Minty]

I find that Index Match allows a much more flexible lookup, you aren't restricted to a single column and the order of columns in the lookup table doesn't matter.

[Welshgasman]

I find that Index Match allows a much more flexible lookup, you aren't restricted to a single column and the order of columns in the lookup table doesn't matter.

I agree, but only use that when I have to.
I purposely set up my data, so I could use a simple Vlookup.

[DMT Dave]

Hi Guy's, I have had a chance to look at this now, if i am correct here, this is how i have broke the formula down in my own method ?

Another question follows, i guess sky is the limit

=INDEX(SheetName
!$C$1:C$100, Column To Populate
MATCH($F$5, Listbox Cell Location
A!$A$1:$A$100 Listbox Source
,0)) Exact Match

Is it possible to have the highlighted blank until a option from the list is selected, even have the list blank ?



hope i have asked this correctly

ie: Bahrain is in the list but not selected ?

reason i ask is if i have ie: 75 contact names, 75 towns, 75 postcodes, i am going to have 75 cells set as listbox

as it stands, every cell would have a value, whereas, can i have the value on selection (blank before selected) ?

Then i guess this part would change from
MATCH($F$1, Listbox Cell Location
To
MATCH($F$1:$F$75, Listbox Cell Location

Just wondering call cells be blank until selected ???

Thank again guy's never really worked with Excel Formulas