Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by timamartin
at 2024-07-15 05:39:22
Point:500 Replies:2 POST_ID:828980USER_ID:10
Topic:
Microsoft Excel Spreadsheet Software;;Spreadsheet Software
I have an Excel spreadsheet with two tabs. Sheet 1 has part information for this month such as part number, description, price, etc. Sheet 2 has a complete list of part numbers in column A and commission percentages in column B.
When I enter a part number in sheet 1 I want it to automatically fill in the percentage based on the source info in sheet two. So I will provide part numbers in sheet one each month and the commission percentage will be filled in automatically based on the info in sheet 2.
When I enter a part number in sheet 1 I want it to automatically fill in the percentage based on the source info in sheet two. So I will provide part numbers in sheet one each month and the commission percentage will be filled in automatically based on the info in sheet 2.
Expert: duncanb7 replied at 2024-07-15 05:47:32
IN sheet2, Excel cell type on A1 cell , for example,
=sheet1!A1 that will call A1 cell value from sheet1 and put it
on sheet2 cell A1
and do anything you want , for example, =sheet1!A1*100/5, and click % on meun bar
Hope understand your question completely.If not, please point it out
Duncan
=sheet1!A1 that will call A1 cell value from sheet1 and put it
on sheet2 cell A1
and do anything you want , for example, =sheet1!A1*100/5, and click % on meun bar
Hope understand your question completely.If not, please point it out
Duncan
Accepted Solution
Expert: NBVC replied at 2024-07-15 05:45:42
500 points EXCELLENT
You can do it with VLOOKUP.
e.g.
=VLOOKUP(A2,'Sheet2'!A:B,2,FALSE)
if there is a possibility of no match and you want to return a blank (or other comment), then use IFERROR()
e.g
=IFERROR(VLOOKUP(A2,'Sheet2'!A:B,2,FALSE),"")
copied down
e.g.
=VLOOKUP(A2,'Sheet2'!A:B,2,FALSE)
if there is a possibility of no match and you want to return a blank (or other comment), then use IFERROR()
e.g
=IFERROR(VLOOKUP(A2,'Sheet2'!A:B,2,FALSE),"")
copied down
